SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweLogros
AS
SELECT     dbo.tb_LOGROS.indicador_id, dbo.tb_LOGROS.anio_logro AS Año, dbo.tb_LOGROS.cantidad, dbo.tb_LOGROS.monto
FROM         dbo.tb_LOGROS INNER JOIN
                      dbo.tb_INDICADOR ON dbo.tb_LOGROS.indicador_id = dbo.tb_INDICADOR.indicador_id
GO
GRANT SELECT ON  [dbo].[vweLogros] TO [MCEEjecutivo]
GRANT INSERT ON  [dbo].[vweLogros] TO [MCEEjecutivo]
GRANT UPDATE ON  [dbo].[vweLogros] TO [MCEEjecutivo]
GRANT SELECT ON  [dbo].[vweLogros] TO [SoloVer]
GO
